Several dimensions in the cube created by iMIS Analytics rely on the Country portion of a contact record's address information. For this reason, it is important to assign a default country code to iMIS contact records that are missing country information.
When the Analytics data warehouse is populated, a special country code (USA by default) is inserted into data from iMIS that does not contain country information. You can change this default country code to a different value at any time.
Note: Changes you make to the default country code affect only the Analytics data warehouse and analysis database. This code is not inserted into your iMIS database. Changes that you make to the default country code are not retroactive.The new default country code will be used only for new records that are brought into the data warehouse.
Before you begin
■ You must perform this procedure on the iMIS application server where Analytics is installed.
■ Analytics must be properly installed and configured. See Installing Analytics for more information.
■ If SQL Server Business Intelligence Development Studio (or any Visual Studio 2005-based window) is currently open on the host, close the Visual Studio window before starting this procedure.
To define a default country code
Caution! The Analytics Configuration tool used in this procedure is meant primarily for advanced development and customization of Analytics. Using this tool for any purpose other than the specific goals of this procedure is unsupported at this time.
1. On the iMIS application server where Analytics is installed, open Windows Explorer and navigate to the C:\Program Files\ASI\iMIS\Analytics folder.
2. Double-click AnalyticsConfiguration.exe.
The Analytics Configuration dialog appears.
3. In the i15.DefaultBlankCountry row, set the Value to a valid 2- or 3-digit country code.
4. Click File > Save.
5. Update the data warehouse and analysis database by manually running the Update iAnalytics Integration Services package. (For more information, see Manually running the Update iAnalytics package.)